๋ชฉํ: ์ฌ์ฉ์ ํ๋ ๊ธฐ๋ฐ ์ํ ์ถ์ฒ ์์คํ
๊ตฌ์ถ์ ์ํ ๋ฐ์ดํฐ ๋ถ์
ํต์ฌ ๊ธฐ๋ฅ: ํด๋ฆญ/์ฅ๋ฐ๊ตฌ๋/๊ตฌ๋งค ์ด๋ ฅ์ ๊ธฐ๋ฐ์ผ๋ก ํ ๋น์ทํ ์ ํ ์ถ์ฒ
| ์์ดํ ID | ์ธ๊ธฐ๋ ์ ์ (view:1, addtocart:3, transaction:10) | ์ ํ์จ (%) | ์นดํ ๊ณ ๋ฆฌ |
|---|---|---|---|
| 461686 | 4787.0 | 5.24 | 1037.0 |
| 187946 | 3416.0 | 0.00 | 1393.0 |
| 5411 | 2352.0 | 0.00 | 789.0 |
| 7943 | 2097.0 | 3.42 | 398.0 |
| 320130 | 2086.0 | 2.48 | 707.0 |
| 320130 | 2086.0 | 2.48 | 707.0 |
| 320130 | 2086.0 | 2.48 | 707.0 |
| 320130 | 2086.0 | 2.48 | 707.0 |
| 320130 | 2086.0 | 2.48 | 707.0 |
| 320130 | 2086.0 | 2.48 | 707.0 |
Events.csv์์ 30๋ถ ์ด๋ด์ ์ด๋ฒคํธ์ด๋ฉด ๊ฐ์ ์ธ์
์ผ๋ก ๊ฐ์ฃผ
์ธ์
ํจํด์ view_only, cart_only, conversion 3๊ฐ์ง๋ก ๋ถ๋ฅ
View Only: view ์ด๋ฒคํธ๋ง ์์ ๋
Cart Only: transaction์ ์์ง๋ง addtocart ์ด๋ฒคํธ๊ฐ ์์ ๋
Conversion: transaction ์ด๋ฒคํธ๊ฐ ํ๋๋ผ๋ ์์ ๋
================================================== 1. ๋ฐ์ดํฐ ๊ธฐ๋ณธ ๊ตฌ์กฐ ํ์ ================================================== EVENTS Shape: (2756101, ['timestamp', 'visitorid', 'event', 'itemid', 'transactionid']) Memory: 234.77 MB Columns: ['timestamp', 'visitorid', 'event', 'itemid', 'transactionid'] ITEM_PROPERTIES Shape: (20275902, ['timestamp', 'itemid', 'property', 'value']) Memory: 2743.19 MB Columns: ['timestamp', 'itemid', 'property', 'value'] CATEGORY_TREE Shape: (1669, ['categoryid', 'parentid']) Memory: 0.03 MB Columns: ['categoryid', 'parentid'] ================================================== 2. ์ด๋ฒคํธ ๋ก๊ทธ ๋ถ์ ================================================== ์ด๋ฒคํธ ํ์ ๋ถํฌ: view: 2,664,312 addtocart: 69,332 transaction: 22,457 ์ ํ ํผ๋: View โ AddToCart: 2.60% AddToCart โ Transaction: 32.39% View โ Transaction: 0.84% ์ฌ์ฉ์ ํ๋ ์์ค: ๊ณ ์ ๋ฐฉ๋ฌธ์ ์: 1,407,580 ์ด ์ด๋ฒคํธ ์: 2,756,101 ๋ฐฉ๋ฌธ์๋น ํ๊ท ์ด๋ฒคํธ ์: 1.96 ================================================== 3. ์ฌ์ฉ์ ํ๋ ํจํด ๋ถ์ ================================================== ์ฌ์ฉ์ ์ ํ ๋ถํฌ: browser: 1,368,715 (97.24%) cart_user: 27,146 (1.93%) buyer: 11,719 (0.83%) ์นดํ ๊ณ ๋ฆฌ ์ ํธ๋๊ฐ ์๋ ์ฌ์ฉ์: 1,236,032 ================================================== 4. ์์ดํ ์ ์ฌ๋ ํน์ฑ ๋ถ์ ================================================== ๋ถ์๋ ์์ดํ ์: 449,240 ์นดํ ๊ณ ๋ฆฌ๊ฐ ์๋ ์์ดํ : 399,425 ์์ 10๊ฐ ์ธ๊ธฐ ์์ดํ : 1. ์์ดํ 461686: ์ธ๊ธฐ๋ 4787.0, ์ ํ์จ 5.24% 2. ์์ดํ 187946: ์ธ๊ธฐ๋ 3416.0, ์ ํ์จ 0.00% 3. ์์ดํ 5411: ์ธ๊ธฐ๋ 2352.0, ์ ํ์จ 0.00% 4. ์์ดํ 7943: ์ธ๊ธฐ๋ 2097.0, ์ ํ์จ 3.42% 5. ์์ดํ 320130: ์ธ๊ธฐ๋ 2086.0, ์ ํ์จ 2.48% 6. ์์ดํ 320130: ์ธ๊ธฐ๋ 2086.0, ์ ํ์จ 2.48% 7. ์์ดํ 320130: ์ธ๊ธฐ๋ 2086.0, ์ ํ์จ 2.48% 8. ์์ดํ 320130: ์ธ๊ธฐ๋ 2086.0, ์ ํ์จ 2.48% 9. ์์ดํ 320130: ์ธ๊ธฐ๋ 2086.0, ์ ํ์จ 2.48% 10. ์์ดํ 320130: ์ธ๊ธฐ๋ 2086.0, ์ ํ์จ 2.48% ================================================== 5. ์ธ์ ๊ธฐ๋ฐ ์ถ์ฒ ๋ถ์ ================================================== ์ธ์ ํต๊ณ: ์ด ์ธ์ ์: 1,761,675 ํ๊ท ์ธ์ ๊ธธ์ด: 1.56 ์ด๋ฒคํธ ํ๊ท ์ธ์ ์๊ฐ: 1.75 ๋ถ ํ๊ท ์ธ์ ๋น ๊ณ ์ ์์ดํ : 1.33 ์ธ์ ํจํด ๋ถํฌ: view_only: 1,715,386 (97.37%) cart_only: 31,992 (1.82%) conversion: 14,297 (0.81%) ================================================== 6. ์ด์ ์ฌ์ฉ์ ํ์ง ================================================== ์ด์์น ํ์ง ๊ฒฐ๊ณผ: ์ด ์ฌ์ฉ์ ์: 1,407,580 ์ด์์น ์ฌ์ฉ์ ์: 301,101 ์ด์์น ๋น์จ: 21.39%
๐ ๋ฆฌํฌํธ ์์ฑ ์๊ฐ: 2025-10-29 08:54:04
๐ ๋ถ์ ๋๊ตฌ: Python, Pandas, Plotly